A GUI for Data Mart Schema Alteration
نویسندگان
چکیده
This paper is interested in the graphical manipulation of data mart schemes described in XML and issued from a generation module of multidimensional models. This manipulation is performed through a set of operations we have defined. These operations consist in adding, deleting and renaming the multidimensional
منابع مشابه
Computer-aided Data-mart Design
With decision support systems, decision-makers analyse data in data marts extracted from production bases. The data-mart schema design is generally performed by expert designers (administrator or computer specialist). With data-driven, requirement-driven or hybrid-driven approaches, this designer builds a data-mart defining facts (analysis subjects) and analysis axes. This process, based on dat...
متن کاملData Mart Schema Construction from Object Oriented Databases
This paper proposes a bottom-up method that helps designers of decision support systems to construct data mart schemas based on an object database. Our method extracts the database schema from the repository of the object DBMS in order to work on the most recent version of the transactional system’s data model. It then applies a set of rules to identify facts, measures, dimensions and their att...
متن کاملData Mart A Data Warehouse Data Mart B Data
EEcient query processing is a critical requirement for data warehousing systems as decision support applications often require minimum response times to answer complex, ad-hoc queries having aggrega-tions, multi-ways joins over vast repositories of data. This can be achieved by fragmenting warehouse data. The data fragmentation concept in the context of distributed databases aims to reduce quer...
متن کاملFrom enterprise models to dimensional models: a methodology for data warehouse and data mart design
This paper describes a method for developing dimensional models from traditional Entity Relationship models. This can be used to design data warehouses and data marts based on enterprise data models. The first step of the method involves classifying entities in the data model into a number of categories. The second step involves identifying hierarchies that exist in the model. The final step in...
متن کاملA Graphical User Interface for Schema Evolution in an Object-Oriented Database
This paper describes work carried out to prototype a GUI to support schema evolution using class versions. Class versions used for schema evolution require a more sophisticated GUI than schema editors (for schema design), because the database is populated an because support is required to browse and maintain the class versions. Current systems for class versioning require exception handlers or ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2006